SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 40076: In SAS® Merchandise Planning, the migration script for upgrading from release 5.x to release 6.x is missing information

DetailsCodeAboutRate It

In SAS Merchandise Planning, the migration script for upgrading from release 5.x to release 6.x is missing information that is needed to populate the Display Name (which is VERSION_SHORT_NM in the MAXDATA.PLANVERSION table).

Note that because the UPDATE script exists in p_copy_planversion, the issue does not occur when you copy a planversion.

The following solution resolves this problem if you do not want to copy a planversion.

To circumvent this problem, run the following UPDATE script using SQL*Plus:

update maxdata.planversion set version_short_nm=SUBSTR(name,1,10) where version_short_nm IS NULL; --commit;


Operating System and Release Information

Product FamilyProductSystemProduct ReleaseSAS Release
ReportedFixed*ReportedFixed*
SAS SystemSAS Merchandise Assortment Planning64-bit Enabled AIX6.1.36.49.1 TS1M3 SP49.4 TS1M0
SAS SystemSAS Merchandise Financial Planning and SAS Merchandise In-Season Management64-bit Enabled AIX6.1.36.49.1 TS1M3 SP49.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.